/// <license>TUSTENA PUBLIC LICENSE v1.0</license>
/// <copyright>
/// Portions Copyright (c) 2003-2006 Digita S.r.l. All Rights Reserved.
///
/// Tustena CRM is a trademark of:
/// Digita S.r.l.
/// Viale Enrico Fermi 14/z
/// 31011 Asolo (Italy)
/// Tel. +39-0423-951251
/// Mail. info@digita.it
///
/// This file contains Original Code and/or Modifications of Original Code
/// as defined in and that are subject to the Tustena Public Source License
/// Version 1.0 (the 'License'). You may not use this file except in
/// compliance with the License. Please obtain a copy of the License at
/// http://www.tustena.com/TPL/ and read it before using this
// file.
///
/// The Original Code and all software distributed under the License are
/// distributed on an 'AS IS' basis, WITHOUT WARRANTY OF ANY KIND, EITHER
/// EXPRESS OR IMPLIED, AND DIGITA S.R.L. HEREBY DISCLAIMS ALL SUCH WARRANTIES,
/// INCLUDING WITHOUT LIMITATION, ANY WARRANTIES OF MERCHANTABILITY,
/// FITNESS FOR A PARTICULAR PURPOSE, QUIET ENJOYMENT OR NON-INFRINGEMENT.
/// Please see the License for the specific language governing rights and
/// limitations under the License.
///
/// YOU MAY NOT REMOVE OR ALTER THIS COPYRIGHT NOTICE!
/// </copyright>

using System;
using System.Data;
using Digita.Tustena.Core;
using Digita.Tustena.Database;

namespace Digita.Tustena.WebGate
{
	public partial class MailAuth : G
	{
		protected void Page_Load(object sender, EventArgs e)
		{
			string guid = DatabaseConnection.FilterInjection(Request.Params["guid"]);
			DataTable dt = DatabaseConnection.CreateDataset("SELECT TABLEID,FIELDID FROM ML_AUTH WHERE ID='" + guid + "'").Tables[0];
			if (dt.Rows.Count > 0)
			{
				DataRow dr = dt.Rows[0];
				switch (dr[0].ToString())
				{
					case "0":

						DatabaseConnection.DoCommand("UPDATE BASE_COMPANIES SET MLFLAG=1 WHERE ID=" + dr[1].ToString());
							DatabaseConnection.DoCommand("INSERT INTO ML_AUTHLOG (TABLEID,RIFID,AUTHTYPE) VALUES (0," + dr[1].ToString() + ",0)");

						break;
					case "1":

						DatabaseConnection.DoCommand("UPDATE BASE_CONTACTS SET MLFLAG=1 WHERE ID=" + dr[1].ToString());
							DatabaseConnection.DoCommand("INSERT INTO ML_AUTHLOG (TABLEID,RIFID,AUTHTYPE) VALUES (1," + dr[1].ToString() + ",0)");

						break;
				}
				DatabaseConnection.DoCommand("DELETE FROM ML_AUTH WHERE ID='" + guid + "'");
			}
			ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('" +Root.rm.GetString("msgauthmail") + "');self.close();</script>");
		}

		#region Codice generato da Progettazione Web Form

		protected override void OnInit(EventArgs e)
		{
			InitializeComponent();
			base.OnInit(e);
		}

		private void InitializeComponent()
		{
			this.Load += new EventHandler(this.Page_Load);
		}

		#endregion
	}
}
